package cn.com.yusys.yusp.admin.domain;

import cn.com.yusys.yusp.commons.excel.annotation.ExcelColumn;
import cn.com.yusys.yusp.commons.excel.annotation.ExcelName;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

@ExcelName(value = "网格客户AUM及产品构成报表", sheet = "网格客户AUM及产品构成报表")
public class GridCustomerAUMAndProductCompositionReportPojo {

    @ExcelColumn(title = "数据日期", index =0)
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    private Date etlDt;
    @ExcelColumn(title = "机构名称", index =1)
    private String gridName;
    @ExcelColumn(title = "档案号", index =2)
    private String userNo;
    @ExcelColumn(title = "网格员姓名", index =3)
    private String userName;
    @ExcelColumn(title = "所属网格", index =4)
    private String secondGridName;
    @ExcelColumn(title = "网格全部客户数", index =5)
    private String custNum;
    @ExcelColumn(title = "网格全部客户AUM（万元）", index =6)
    private String custAum;
    @ExcelColumn(title = "高净值客户数", index =7)
    private String gjzCustNum;
    @ExcelColumn(title = "高净值客户AUM（万元）", index =8)
    private String gjzCustAum;
    @ExcelColumn(title = "高净值客户存款月日均（万元）", index =9)
    private String gjzDepAvg;
    @ExcelColumn(title = "高净值客户贷款月日均（万元）", index =10)
    private String gjzLoanAvg;
    @ExcelColumn(title = "高净值客户理财月日均（万元）", index =11)
    private String gjzFincAvgM;
    @ExcelColumn(title = "高净值客户基金月日均（万元）", index =12)
    private String gjzFundAvgM;
    @ExcelColumn(title = "财富高端客户数", index =13)
    private String cfgdCustNum;
    @ExcelColumn(title = "财富高端客户AUM（万元）", index =14)
    private String cfgdCustAum;
    @ExcelColumn(title = "财富高端客户存款月日均（万元）", index =15)
    private String cfgdDepAvgM;
    @ExcelColumn(title = "财富高端客户贷款月日均（万元）", index =16)
    private String cfgdLoanAvgM;
    @ExcelColumn(title = "财富高端客户理财月日均（万元）", index =17)
    private String cfgdFincAvgM;
    @ExcelColumn(title = "财富高端客户基金月日均（万元）", index =18)
    private String cfgdFundAvgM;
    @ExcelColumn(title = "财富中高端客户数", index =19)
    private String cfzgCustNum;
    @ExcelColumn(title = "财富中高端客户AUM（万元）", index =20)
    private String cfzgCustAum;
    @ExcelColumn(title = "财富中高端客户存款月日均（万元）", index =21)
    private String cfzgDepAvgM;
    @ExcelColumn(title = "财富中高端客户贷款月日均（万元）", index =22)
    private String cfzgLoanAvgM;
    @ExcelColumn(title = "财富中高端客户理财月日均（万元）", index =23)
    private String cfzgFincAvgM;
    @ExcelColumn(title = "财富中高端客户基金月日均（万元）", index =24)
    private String cfzgFundAvgM;
    @ExcelColumn(title = "中端客户数", index =25)
    private String zdCustNum;
    @ExcelColumn(title = "中端客户AUM（万元）", index =26)
    private String zdCustAum;
    @ExcelColumn(title = "中端客户存款月日均（万元）", index =27)
    private String zdDepAvgM;
    @ExcelColumn(title = "中端客户贷款月日均（万元）", index =28)
    private String zdLoanAvgM;
    @ExcelColumn(title = "中端客户理财月日均（万元）", index =29)
    private String zdFincAvgM;
    @ExcelColumn(title = "中端客户基金月日均（万元）", index =30)
    private String zdFundAvgM;
    @ExcelColumn(title = "大众客户数", index =31)
    private String dzCustNum;
    @ExcelColumn(title = "大众客户AUM（万元）", index =32)
    private String dzCustAum;
    @ExcelColumn(title = "大众客户存款月日均（万元）", index =33)
    private String dzDepAvgM;
    @ExcelColumn(title = "大众客户贷款月日均（万元）", index =34)
    private String dzLoanAvgM;
    @ExcelColumn(title = "大众客户理财月日均（万元）", index =35)
    private String dzFincAvgM;
    @ExcelColumn(title = "大众客户基金月日均（万元）", index =36)
    private String dzFundAvgM;

    public Date getEtlDt() {
        return etlDt;
    }

    public void setEtlDt(Date etlDt) {
        this.etlDt = etlDt;
    }

    public String getGridName() {
        return gridName;
    }

    public void setGridName(String gridName) {
        this.gridName = gridName;
    }

    public String getUserNo() {
        return userNo;
    }

    public void setUserNo(String userNo) {
        this.userNo = userNo;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getSecondGridName() {
        return secondGridName;
    }

    public void setSecondGridName(String secondGridName) {
        this.secondGridName = secondGridName;
    }

    public String getCustNum() {
        return custNum;
    }

    public void setCustNum(String custNum) {
        this.custNum = custNum;
    }

    public String getCustAum() {
        return custAum;
    }

    public void setCustAum(String custAum) {
        this.custAum = custAum;
    }

    public String getGjzCustNum() {
        return gjzCustNum;
    }

    public void setGjzCustNum(String gjzCustNum) {
        this.gjzCustNum = gjzCustNum;
    }

    public String getGjzCustAum() {
        return gjzCustAum;
    }

    public void setGjzCustAum(String gjzCustAum) {
        this.gjzCustAum = gjzCustAum;
    }

    public String getGjzDepAvg() {
        return gjzDepAvg;
    }

    public void setGjzDepAvg(String gjzDepAvg) {
        this.gjzDepAvg = gjzDepAvg;
    }

    public String getGjzLoanAvg() {
        return gjzLoanAvg;
    }

    public void setGjzLoanAvg(String gjzLoanAvg) {
        this.gjzLoanAvg = gjzLoanAvg;
    }

    public String getGjzFincAvgM() {
        return gjzFincAvgM;
    }

    public void setGjzFincAvgM(String gjzFincAvgM) {
        this.gjzFincAvgM = gjzFincAvgM;
    }

    public String getGjzFundAvgM() {
        return gjzFundAvgM;
    }

    public void setGjzFundAvgM(String gjzFundAvgM) {
        this.gjzFundAvgM = gjzFundAvgM;
    }

    public String getCfgdCustNum() {
        return cfgdCustNum;
    }

    public void setCfgdCustNum(String cfgdCustNum) {
        this.cfgdCustNum = cfgdCustNum;
    }

    public String getCfgdCustAum() {
        return cfgdCustAum;
    }

    public void setCfgdCustAum(String cfgdCustAum) {
        this.cfgdCustAum = cfgdCustAum;
    }

    public String getCfgdDepAvgM() {
        return cfgdDepAvgM;
    }

    public void setCfgdDepAvgM(String cfgdDepAvgM) {
        this.cfgdDepAvgM = cfgdDepAvgM;
    }

    public String getCfgdLoanAvgM() {
        return cfgdLoanAvgM;
    }

    public void setCfgdLoanAvgM(String cfgdLoanAvgM) {
        this.cfgdLoanAvgM = cfgdLoanAvgM;
    }

    public String getCfgdFincAvgM() {
        return cfgdFincAvgM;
    }

    public void setCfgdFincAvgM(String cfgdFincAvgM) {
        this.cfgdFincAvgM = cfgdFincAvgM;
    }

    public String getCfgdFundAvgM() {
        return cfgdFundAvgM;
    }

    public void setCfgdFundAvgM(String cfgdFundAvgM) {
        this.cfgdFundAvgM = cfgdFundAvgM;
    }

    public String getCfzgCustNum() {
        return cfzgCustNum;
    }

    public void setCfzgCustNum(String cfzgCustNum) {
        this.cfzgCustNum = cfzgCustNum;
    }

    public String getCfzgCustAum() {
        return cfzgCustAum;
    }

    public void setCfzgCustAum(String cfzgCustAum) {
        this.cfzgCustAum = cfzgCustAum;
    }

    public String getCfzgDepAvgM() {
        return cfzgDepAvgM;
    }

    public void setCfzgDepAvgM(String cfzgDepAvgM) {
        this.cfzgDepAvgM = cfzgDepAvgM;
    }

    public String getCfzgLoanAvgM() {
        return cfzgLoanAvgM;
    }

    public void setCfzgLoanAvgM(String cfzgLoanAvgM) {
        this.cfzgLoanAvgM = cfzgLoanAvgM;
    }

    public String getCfzgFincAvgM() {
        return cfzgFincAvgM;
    }

    public void setCfzgFincAvgM(String cfzgFincAvgM) {
        this.cfzgFincAvgM = cfzgFincAvgM;
    }

    public String getCfzgFundAvgM() {
        return cfzgFundAvgM;
    }

    public void setCfzgFundAvgM(String cfzgFundAvgM) {
        this.cfzgFundAvgM = cfzgFundAvgM;
    }

    public String getZdCustNum() {
        return zdCustNum;
    }

    public void setZdCustNum(String zdCustNum) {
        this.zdCustNum = zdCustNum;
    }

    public String getZdCustAum() {
        return zdCustAum;
    }

    public void setZdCustAum(String zdCustAum) {
        this.zdCustAum = zdCustAum;
    }

    public String getZdDepAvgM() {
        return zdDepAvgM;
    }

    public void setZdDepAvgM(String zdDepAvgM) {
        this.zdDepAvgM = zdDepAvgM;
    }

    public String getZdLoanAvgM() {
        return zdLoanAvgM;
    }

    public void setZdLoanAvgM(String zdLoanAvgM) {
        this.zdLoanAvgM = zdLoanAvgM;
    }

    public String getZdFincAvgM() {
        return zdFincAvgM;
    }

    public void setZdFincAvgM(String zdFincAvgM) {
        this.zdFincAvgM = zdFincAvgM;
    }

    public String getZdFundAvgM() {
        return zdFundAvgM;
    }

    public void setZdFundAvgM(String zdFundAvgM) {
        this.zdFundAvgM = zdFundAvgM;
    }

    public String getDzCustNum() {
        return dzCustNum;
    }

    public void setDzCustNum(String dzCustNum) {
        this.dzCustNum = dzCustNum;
    }

    public String getDzCustAum() {
        return dzCustAum;
    }

    public void setDzCustAum(String dzCustAum) {
        this.dzCustAum = dzCustAum;
    }

    public String getDzDepAvgM() {
        return dzDepAvgM;
    }

    public void setDzDepAvgM(String dzDepAvgM) {
        this.dzDepAvgM = dzDepAvgM;
    }

    public String getDzLoanAvgM() {
        return dzLoanAvgM;
    }

    public void setDzLoanAvgM(String dzLoanAvgM) {
        this.dzLoanAvgM = dzLoanAvgM;
    }

    public String getDzFincAvgM() {
        return dzFincAvgM;
    }

    public void setDzFincAvgM(String dzFincAvgM) {
        this.dzFincAvgM = dzFincAvgM;
    }

    public String getDzFundAvgM() {
        return dzFundAvgM;
    }

    public void setDzFundAvgM(String dzFundAvgM) {
        this.dzFundAvgM = dzFundAvgM;
    }
}
